7 of 14

For this step you'll need full access to the ColdFusion Administrator application on each server in the cluster. Here's what to do in detail:

a.  Start the ColdFusion Administrator (usually found by clicking Start | Programs | ColdFusion Server 4.x | ColdFusion Administrator).
b.  Log in using the password for administrator access that you chose when CF Server was installed.
c.  Click on ODBC under the Data Sources section on the left sidebar.
d.  Type the data source name ("CVR" in this example), choose the ODBC Driver ("Microsoft SQL Server Driver" in this example) and click the Add button.
e.  Enter the name or IP address of the database server in the Server field.
f.  In the database field enter the name of the database you created in Step 1 ("CVR" in this example).
g.  Click the CF Settings button and complete the username and password fields to access this database.
h.  Make sure Maintain Database Connections is checked.
i.  Click the Create button. After the data source is created you should see your list of data sources again, with "verified" next to the data source you just created. If you don't see "verified," you must take whatever steps are necessary until this server is able to connect to the data source. The connection must be verified before you can continue.

  • 2.2: Configure client variable storage.

    Now that you've created the data source, you will configure the server(s) to use that data source to store client variables.Here's how to do so in detail:

    a.  Under the Server category in the left sidebar, click Variables.
    b.  You will see a select box at the top, under Name. Choose the data source you created above ("CVR" in this example) from the select box, and click Add.
    c.  On the page that loads next, choose the number of days you wish to have client variables stored in your database. The default is 10 days.
    d.  For higher-traffic sites, you may wish to select Disable Global Client Variable Updates. In the beginning, try leaving them enabled; if performance suffers, you can place a check in this box later. Keep in mind that if you write code that depends upon the automatic updating of such client variables as "LVISIT" (the last date/time the client with that CFID loaded a page) and "HITCOUNT" (the number of page impressions by a particular client), your code will break if you disable global updates later.

    7 of 14